1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Drawing;
5 using System.Data;
6 using System.Linq;
7 using System.Text;
8 using System.Threading.Tasks;
9 using System.Windows.Forms;
10 using System.Data.SqlClient;
11 /*
12 namespace SoftQuanLyNhaHang.Models
13 {
14 class NhapKhoMod
15 {
16
17 protected int IdNhapKho { get; set; }
18 protected string MaSanPham { get; set; }
19 protected string TenSanPham { get; set; }
20 protected int SoLuong { get; set; }
21 protected int DonViTinhId { get; set; }
22 protected string TenDonViTinh { get; set; }
23 protected string GiaNhap { get; set; }
24 protected string NgaySanXuat { get; set; }
25 protected string HanSuDung { get; set; }
26 protected string HoVaTen { get; set; }
27 protected string SoDienThoai { get; set; }
28 protected string DiaChi { get; set; }
29 protected string GhiChu { get; set; }
30 protected string ThanhTien { get; set; }
31 protected int KhachHangId { get; set; }
32
33
34 protected string GiaBanLe { get; set; }
35 protected string GiaBanBuon { get; set; }
36 protected DateTime NgayTao { get; set; }
37
38
39 protected int PageSize {get; set;}
40 protected int PageIndex { get; set; }
41
42 public NhapKhoMod(int _IdNhapKho)
43 {
44 IdNhapKho = _IdNhapKho;
45 }
46
47
48 public NhapKhoMod(string _maSanPham)
49 {
50 MaSanPham = _maSanPham;
51 }
52
53 public NhapKhoMod(string _maSanPham, string _soDienThoai)
54 {
55 MaSanPham = _maSanPham;
56 SoDienThoai = _soDienThoai;
57 }
58
59 public NhapKhoMod(string _maSanPham, int _khachHangId)
60 {
61 MaSanPham = _maSanPham;
62 KhachHangId = _khachHangId;
63 }
64
65 public NhapKhoMod(int _pageSize, int _pageIndex)
66 {
67 PageSize = _pageSize;
68 PageIndex = _pageIndex;
69 }
70
71 public NhapKhoMod()
72 {
73
74 }
75
76 public NhapKhoMod(int _idNhapKho, string _maSanPham, string _tenSanPham, int _soLuong, int _donViTinhId, string _tenDonViTinh, string _giaNhap, string _ngaySanXuat, string _hanSuDung, string _hoVaTen, string _soDienThoai, string _diaChi, string _ghiChu, string _thanhTien, string _giaBanLe, string _giaBanBuon, DateTime _ngayTao)
77 {
78 IdNhapKho = _idNhapKho;
79 MaSanPham = _maSanPham;
80 TenSanPham = _tenSanPham;
81 SoLuong = _soLuong;
82 DonViTinhId = _donViTinhId;
83 TenDonViTinh = _tenDonViTinh;
84 GiaNhap = _giaNhap;
85 NgaySanXuat = _ngaySanXuat;
86 HanSuDung = _hanSuDung;
87 HoVaTen = _hoVaTen;
88 SoDienThoai = _soDienThoai;
89 DiaChi = _diaChi;
90 GhiChu = _ghiChu;
91 ThanhTien = _thanhTien;
92 GiaBanLe = _giaBanLe;
93 GiaBanBuon = _giaBanBuon;
94 NgayTao = _ngayTao;
95 }
96
97 public int InsertNhapKho()
98 {
99 int i = 0;
100 string[] paras = new string[17] { "@IdNhapKho", "@MaSanPham", "@TenSanPham", "@SoLuong", "@DonViTinhId", "@TenDonViTinh", "@GiaNhap", "@NgaySanXuat", "@HanSuDung", "@HoVaTen", "@SoDienThoai", "@DiaChi", "@GhiChu", "@ThanhTien", "@GiaBanLe", "@GiaBanBuon", "@NgayTao"};
101 object[] values = new object[17] { IdNhapKho, MaSanPham, TenSanPham, SoLuong, DonViTinhId, TenDonViTinh, GiaNhap, NgaySanXuat, HanSuDung, HoVaTen, SoDienThoai, DiaChi, GhiChu, ThanhTien, GiaBanLe, GiaBanBuon, NgayTao};
102 i = Int32.Parse( Models.connection.ExcuteScalar("tbl_NhapKho_Insert", CommandType.StoredProcedure, paras, values));
103 return i;
104 }
105 public int UpdateNhapKho()
106 {
107 int i = 0;
108 string[] paras = new string[17] { "@IdNhapKho", "@MaSanPham", "@TenSanPham", "@SoLuong", "@DonViTinhId", "@TenDonViTinh", "@GiaNhap", "@NgaySanXuat", "@HanSuDung", "@HoVaTen", "@SoDienThoai", "@DiaChi", "@GhiChu", "@ThanhTien", "@GiaBanLe", "@GiaBanBuon", "@NgayTao"};
109 object[] values = new object[17] { IdNhapKho, MaSanPham, TenSanPham, SoLuong, DonViTinhId, TenDonViTinh, GiaNhap, NgaySanXuat, HanSuDung, HoVaTen, SoDienThoai, DiaChi, GhiChu, ThanhTien, GiaBanLe, GiaBanBuon, NgayTao};
110 i = Models.connection.Excute_Sql("tbl_NhapKho_Update", CommandType.StoredProcedure, paras, values);
111 return i;
112 }
113 public int DeleteNhapKho()
114 {
115 int i = 0;
116 string[] paras = new string[1] { "@IdNhapKho" };
117 object[] values = new object[1] { IdNhapKho };
118 i = Models.connection.Excute_Sql("tbl_NhapKho_Delete", CommandType.StoredProcedure, paras, values);
119 return i;
120 }
121
122 //Hiển thị ra combox
123 public static DataSet FillDataSet_getTenDonViTinh()
124 {
125 return Models.connection.FillDataSet("spgetTenDonViTinh", CommandType.StoredProcedure);
126 }
127
128 //danh sach
129 public static DataSet FillDataSet_get_tbl_NhapKho_GetAll()
130 {
131 return Models.connection.FillDataSet("tbl_NhapKho_GetAll", CommandType.StoredProcedure);
132 }
133
134 public DataSet FillDataSet_getNhapKhoByMaSanPham()
135 {
136 DataSet ds = new DataSet();
137 string[] paras = new string[1] { "@MaSanPham" };
138 object[] values = new object[1] { MaSanPham };
139 ds = Models.connection.FillDataSet("tbl_NhapKho_Get_ByMaSanPham", CommandType.StoredProcedure, paras, values);
140 return ds;
141 }
142
143 public DataSet FillDataSet_getSearchByMaSanPham()
144 {
145 DataSet ds = new DataSet();
146 string[] paras = new string[2] { "@MaSanPham", "@KhachHangId" };
147 object[] values = new object[2] { MaSanPham , KhachHangId};
148 ds = Models.connection.FillDataSet("tbl_NhapKhoSearchByMaSanPham", CommandType.StoredProcedure, paras, values);
149 return ds;
150 }
151
152
153 public DataSet FillDataSet_getNhapKhoBySoDienThoai()
154 {
155 DataSet ds = new DataSet();
156 string[] paras = new string[2] {"@MaSanPham", "@SoDienThoai" };
157 object[] values = new object[2] { MaSanPham, SoDienThoai };
158 ds = Models.connection.FillDataSet("tbl_NhapKho_Get_BySoDienThoai", CommandType.StoredProcedure, paras, values);
159 return ds;
160 }
161
162 //Hiển thị tất cả
163 public DataSet FillDataSet_tbl_NhapKho_Search()
164 {
165 DataSet ds = new DataSet();
166 string[] paras = new string[2] { "@PageSize", "@PageIndex" };
167 object[] values = new object[2] { PageSize, PageIndex };
168 ds = Models.connection.FillDataSet("tbl_NhapKho_Search", CommandType.StoredProcedure, paras, values);
169 return ds;
170 }
171
172 }
173 }
174
175 */